SRExchRiskDrop
METADATA
| Attribute | Value |
|---|---|
| Topic | 1450-away-drop |
| MLink Token | ClientTrading |
| Product | SRTrade |
| accessType | SELECT |
| MLink Endpoint | MLink-Order |
Table Definition
| Field | Type | Key | Default Value | Comment |
|---|---|---|---|---|
| exchDropNumber | BIGINT | PRI | 0 | SR Unique ID |
| routingCode | TINYTEXT | '' | drop session routing code | |
| routingSeqNum | INT | 0 | drop session routingSeqNum | |
| routeRiskGroup | VARCHAR(32) | '' | unique code grouping this drop session with 1 or more outbound street sessions | |
| secKey_at | enum - AssetType | 'None' | ||
| secKey_ts | enum - TickerSrc | 'None' | ||
| secKey_tk | VARCHAR(12) | '' | ||
| secKey_yr | SMALLINT UNSIGNED | 0 | ||
| secKey_mn | TINYINT UNSIGNED | 0 | ||
| secKey_dy | TINYINT UNSIGNED | 0 | ||
| secKey_xx | DOUBLE | 0 | ||
| secKey_cp | enum - CallPut | 'Call' | ||
| secType | enum - SpdrKeyType | 'None' | ||
| account | TINYTEXT | '' | FixTag1 | |
| dropData1 | TINYTEXT | '' | ||
| dropData2 | TINYTEXT | '' | ||
| clOrdId | VARCHAR(32) | '' | child order clOrdId | |
| fillVersion | TINYINT UNSIGNED | 0 | cancelcorrect version number initial fill is version1 | |
| fillExecStatus | enum - ExecStatus | 'None' | SpiderRock execution status FillBustCorrectRejectSysRej | |
| fillDttm | DATETIME(6) | '1900-01-01 00:00:00.000000' | fill DateTime from SRDateTime | |
| fillQuantity | INT | 0 | fill size from execReportlastSize | |
| fillSide | enum - BuySell | 'None' | fill side from execReportside | |
| fillPrice | DOUBLE | 0 | fill price from execReportlastPrice | |
| fillTransactDttm | DATETIME(6) | '1900-01-01 00:00:00.000000' | fill DateTime from execReportfillDttm | |
| fillMarket | VARCHAR(8) | '' | fill market from execReportlastMarket | |
| fillExecId | TINYTEXT | '' | fill execution id from execReportexecId | |
| fillRefExecId | TINYTEXT | '' | fill ref execution id from execReportrefExecId only set on a cancel or correct | |
| fillLegRefId | BIGINT | 0 | fill leg ref id from execReportlegRefId | |
| fillStreetText | TINYTEXT | '' | ||
| netTimestamp | BIGINT | 0 | drop gateway arrival timestamp | |
| timestamp | DATETIME(6) | '1900-01-01 00:00:00.000000' |
PRIMARY KEY DEFINITION (Unique)
| Field | Sequence |
|---|---|
| exchDropNumber | 1 |
SELECT TABLE EXAMPLE QUERY
SELECT *
FROM `SRTrade`.`MsgSRExchRiskDrop`
WHERE
/* Replace with a BIGINT */
`exchDropNumber` = 1234567890;
Doc Columns Query
SELECT * FROM SRTrade.doccolumns WHERE TABLE_NAME='SRExchRiskDrop' ORDER BY ordinal_position ASC;